
/****** Object:  Table [dbo].[Invoice_BankRemit]    Script Date: 01/11/2021 15:15:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_BankRemit](
	[inv_BankRemitID] [bigint] IDENTITY(1,1) NOT NULL,
	[VoucherID] [bigint] NOT NULL,
	[BankID] [int] NULL,
	[BankDate] [datetime] NOT NULL,
	[EPRC] [varchar](100) NULL,
	[Remit] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_BankRemit_Remit]  DEFAULT ((0)),
	[FBC] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_BankRemit_FBC]  DEFAULT ((0)),
	[RemitNet] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_BankRemit_RemitNet]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_BankRemit_Type]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_BankRemit] PRIMARY KEY CLUSTERED 
(
	[inv_BankRemitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

